package blackhouse_server;

import java.sql.SQLException;
import java.util.List;

import blackhouse_dao.student_dao;
import blackhouse_entity.student;

public class Check_student_server
{
	public List<student> seekstudent(String name, String num)
			throws SQLException
	{
		student_dao stu = new student_dao();
		String sql = "select * from student a LEFT JOIN classtable b ON a.`classID` = b.`id` where stuName like '%"
				+ name + "%' and stuCode like '%" + num + "%'";
		return stu.show_student(sql, "4");
	}
}
